package com.linkstec.spark.base;

public interface MotConst {
	String STORM_CONFIG_PREFIX = "stormconfig.";

	int UUIDLEN = 36;
	String createBnckTransSql = "CREATE TABLE IF NOT EXISTS "
			+ "default.BANK_TRANS (TRANS_FLOW_ID INT COMMENT '转账流水 ', "
			+ "CUST_NO STRING COMMENT '客户号', "
			+ "FUND_ID STRING COMMENT '资金账户', "
			+ "BALANCE STRING COMMENT '转账金额', "
			+ "TRANS_TYPE STRING COMMENT '转账方式', "
			+ "TRD_DATE STRING COMMENT '转账日期', "
			+ "TRD_TIME STRING COMMENT '转账时间') "
//			+ "clustered by (TRANS_FLOW_ID) into 2 buckets stored as orc TBLPROPERTIES('transactional'='true') "
			+ "ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ";
	String createEventFlowSql = "CREATE TABLE IF NOT EXISTS "
			+ "default.E_EVENT_FLOW (EVENT_FLOW_ID INT, "
			+ "EVENT_ID STRING, "
			+ "BRANCH_ID STRING, "
			+ "EXTRA_ID STRING, "
			+ "CUST_NO STRING, "
			+ "EVENT_TRG_TIME DATE, "
			+ "DEAD_LINE STRING, "
			+ "APPENDINFORMATION STRING) "
			+ "ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ";
}
